Mondial Database

Schema description

Table of contents

 

Index

Types

Tables

Type GeoCoord (definition)

Latitude:geographic latitude
Longitude:geographic longitude

Table Country (definition)

Name:the country name
Code:the internet country code (two letters)
Capital:the name of the capital
Province:the province where the capital belongs to
Population:the population number
Area:the total area

Table Province (definition)

Name:the name of the administrative division
Country:the country code where it belongs to
Population:the population of the province
Area:the total area of the province
Capital:the name of the capital
CapProv:the name of the province where the captital belongs to

Table City (definition)

Name:the name of the city
Country:the country code where it belongs to
Province:the name of the province where it belongs to
Population:population of the city
Latitude:geographic latitude
Longitude:geographic longitude

Table Continent (definition)

Name:name of the continent
Area:total area of the continent

Table encompasses (definition)

Country:the country code
Continent:the continent name
Percentage:percentage, how much of the area of a country belongs to the continent

Table borders (definition)

Country1:a country code
Country2:a country code
Length:length of the border between country1 and country2

Table Organization (definition)

Abbreviation:the abbreviation of the organization
Name:the full name of the organization
Established:date of establishment
City:the city where it is seated
Province:the province of its seat
Country:the country code of its seat

Table is_member (definition)

Organization:the abbreviation of the organization
Country:the code of the member country
Type:the type of membership

Table Economy (definition)

Country:the country code
GDP:gross domestic product (in million dollar)
Agriculture:percentage of agricultural sector of the GDP
Industry:percentage of industrial sector of the GDP
Services:percentage of service sector of the GDP
Inflation:inflation rate (percentage, per annum)

Table Population (definition)

Country:the country code
Population_Growth:population growth rate (percentage, per annum)
Infant_Mortality:infant mortality (per thousand)

Table Politics (definition)

Country:the country code
Independence:date of independence
Government:type of government

Table Language (definition)

Country:the country code
Name:name of the language
Percentage:percentage of the language in this country

Table Religion (definition)

Country:the country code
Name:name of the religion
Percentage:percentage of the religion in this country

Table Ethnic_Group (definition)

Country:the country code
Name:name of the ethnic group
Percentage:percentage of the ethnic group in this country

Table located (definition)

City:the name of the city
Province:the province where the city belongs to
Country:the country code where the city belongs to
River:the river where it is located at
Lake:the lake where it is located at
Sea:the sea where it is located at

Table River (definition)

Name:the name of the river
River:the river where it flows to
Lake:the lake where it flows to
Sea:the sea where it flows to
Length:the length of the river

Table Mountain (definition)

Name:the name of the mountain
Height:the height of the mountain
Coordinates:its geographical coordinates as (longitude, latitude)

Table Lake (definition)

Name:the name of the lake
Area:the total area of the lake

Table Sea (definition)

Name:the name of the sea
Depth:the maximal depth of the sea

Table Island (definition)

Name:the name of the island
Islands:the group of the islands where it belongs to
Area:the total area of the island
Coordinates:its geographical coordinates as (longitude, latitude)

Table Desert (definition)

Name:the name of the desert
Area:the total area of the desert

Table geo_river (definition)

River:the name of the river
Country:the country code where it is located
Province:the province of this country

Table geo_mountain (definition)

Mountain:the name of the mountain
Country:the country code where it is located
Province:the province of this country

Table geo_lake (definition)

Lake:the name of the lake
Country:the country code where it is located
Province:the province of this country

Table geo_sea (definition)

Sea:the name of the sea
Country:the country code where it is located
Province:the province of this country

Table geo_island (definition)

Island:the name of the island
Country:the country code where it is located
Province:the province of this country

Table geo_desert (definition)

Desert:the name of the desert
Country:the country code where it is located
Province:the province of this country

Table merges_with (definition)

Sea1:a sea
Sea2:a sea